package com.simtop.mapper;


import com.simtop.pojo.*;
import com.simtop.vo.LabVo;
import jnr.ffi.annotations.In;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.ArrayList;
import java.util.List;

//基础表mapper

@Mapper
public interface SqyxBaseMapper {

   List<SqyxBase> selectAllPeoper();

   List<SqyxBase> selectAllPeoper2();

   int findCountab(@Param("sex") String sex, @Param("membergrade") String membergrade, @Param("Productcategoryone") String cp, @Param("startsp") Integer startsp, @Param("endsp") Integer endsp,
                   @Param("profession") String profession,
                   @Param("area") String area,
                   @Param("constellation") String constellation,
                   @Param("max") Integer max,
                   @Param("small") Integer small,
                   @Param("dzmax") Integer dzmax,
                   @Param("dzsmall") Integer dzsmall,
                   @Param("htmax") Integer htmax,
                   @Param("htsmall") Integer htsmall,
                   @Param("fwstarttimes") String fwstarttimes,
                   @Param("fwendtimes") String fwendtimes,
                   @Param("zcstarttimes") String zcstarttimes,
                   @Param("zcendtimes") String zcendtimes,
                   @Param("kdjmax") Integer kdjmax,
                   @Param("kdjsmall") Integer kdjsmall,
                   @Param("hymax") Integer hymax,
                   @Param("hysmall") Integer hysmall,
                   @Param("xq") String xq,
                   @Param("newsstarttimes") String newsstarttimes,
                   @Param("newsendtimes") String newsendtimes,
                   @Param("speakstarttimes") String speakstarttimes,
                   @Param("speakendtimes") String speakendtimes,
                   @Param("signinstarttimes") String signinstarttimes,
                   @Param("signinendtimes") String signinendtimes,
                   @Param("cistarttimes") String cistarttimes,
                   @Param("ciendtimes") String ciendtimes,
                   @Param("sharestarttimes") String sharestarttimes,
                   @Param("shareendtimes") String shareendtimes);

   int findCountnew(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);


   SqyxBase findAllById(int id);

   int gitAllPeoper();

   List<String> findAllByName(@Param("sex") String sex, @Param("membergrade") String membergrade, @Param("Productcategoryone") String cp, @Param("startsp") Integer startsp, @Param("endsp") Integer endsp,
                              @Param("profession") String profession,
                              @Param("area") String area,
                              @Param("constellation") String constellation,
                              @Param("max") Integer max,
                              @Param("small") Integer small,
                              @Param("dzmax") Integer dzmax,
                              @Param("dzsmall") Integer dzsmall,
                              @Param("htmax") Integer htmax,
                              @Param("htsmall") Integer htsmall,
                              @Param("fwstarttimes") String fwstarttimes,
                              @Param("fwendtimes") String fwendtimes,
                              @Param("zcstarttimes") String zcstarttimes,
                              @Param("zcendtimes") String zcendtimes,
                              @Param("kdjmax") Integer kdjmax,
                              @Param("kdjsmall") Integer kdjsmall,
                              @Param("hymax") Integer hymax,
                              @Param("hysmall") Integer hysmall,
                              @Param("xq") String xq,
                              @Param("newsstarttimes") String newsstarttimes,
                              @Param("newsendtimes") String newsendtimes,
                              @Param("speakstarttimes") String speakstarttimes,
                              @Param("speakendtimes") String speakendtimes,
                              @Param("signinstarttimes") String signinstarttimes,
                              @Param("signinendtimes") String signinendtimes,
                              @Param("cistarttimes") String cistarttimes,
                              @Param("ciendtimes") String ciendtimes,
                              @Param("sharestarttimes") String sharestarttimes,
                              @Param("shareendtimes") String shareendtimes);

   LocalDistributionVo findlocal(@Param("objects") List<String> objects);


   List<String> findAllNameNews(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   AgedistributionVo getageDistribution(@Param("objects") List<String> objects);

   SexCount gitsex(@Param("objects") List<String> objects);

   ConsumptVo getsr(@Param("objects") List<String> objects);

   List<SqyxBase> selectAllPeoperByNewTime(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   SexCount findTime(@Param("everday") String everday);

   List<NewAreaVo> findarea(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   List<Productvo> findcategoryByDate(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   QdVo findqd(@Param("everday") String everday);

   int fincount(@Param("everday") String everday);

   List<NewMemberVo> findmamber(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes,@Param("names") List<String> names);

   int findyn(@Param("everday") String everday);

   int findtop(@Param("everday") String everday);

   int findtoptop(@Param("everday") String everday);

   int findtopic(@Param("everday") String everday);

   List<NewInere> finInsere(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int findallshare(@Param("everday") String everday);

   int findallpro(@Param("everday") String everday);

   List<CyyxVo> finacyyx(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   List<CyyxVo> finacyyxx(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   List<CyyxVo> finacyyxxx(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   double findzh(@Param("everday") String everday);

   UserZhVo findregister(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   double findfg(@Param("everday") String everday);

   UserZhVo findregisterr(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   NewKdVo finzje(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   NewKdVo findsjcp(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes, @Param("userlb") String userlb);

   NewKdVo findsjcps(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes, @Param("userlb") String userlb);

   PcVo finpc(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   PcVo finpcc(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes, @Param("pc") String pc);

   List<String> gitlb();

   int findlsrq();

   int findlcrq();

   Float lcqd();


   Float lsqd();

   Float lcfy();

   float lsfy();

   float lcll();

   float lsll();

   float lsxd();

   float lcxd();

   float lsdl();

   float lcdl();

   int finsjsex1(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjsex2(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjsex3(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjcon1(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjcon2(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjcon3(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjedu1(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjedu2(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjedu3(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjarea1(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjarea2(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjarea3(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);


   int finsjcha1(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjcha2(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjcha3(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjsig1(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjsig2(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjsig3(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjmem1(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjmem2(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjmem3(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjmemb1(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjmemb2(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int finsjmemb3(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int findCountlb1(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int findCountlb2(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   int findCountlb3(@Param("usersr") String usersr, @Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

    List<SqyxBase> getAllName();

   int getAllCountss(@Param("topicone") String topicone,@Param("topictwo") String topictwo,@Param("topicthree") String topicthree);

   List<String> getAllCountsss(@Param("topicone") String topicone,@Param("topictwo") String topictwo,@Param("topicthree") String topicthree);

   List<SqyxBase> selectAllPeoperByNewTime01(@Param("signin") String signin ,@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);


   List<SqyxBase> selectAllPeoperByNewTime02(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   List<SqyxBase> selectAllPeoperByNewTime03(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   List<SqyxBase> selectAllPeoperByNewTime04(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   List<NewAreaVo> findareaqd(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   SexCount findTimeqd(@Param("everday") String everday);

   List<NewAreaVo> findareafy(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   SexCount findTimefy(@Param("everday") String everday);

   List<NewAreaVo> findareaht(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);

   SexCount findTimeht(@Param("everday") String everday);

   List<NewAreaVo> findareafx(@Param("starttimes") String starttimes, @Param("endtimes") String endtimes);


   SexCount findTimefx(@Param("everday") String everday);

   List<String> findlsrqls();

   List<String> findlsrqlslc();

   int findCountnewbuy(@Param("usersr") String usersr,@Param("starttimes") String starttimes,@Param("endtimes") String endtimes);

   int findCountnewbuybig(@Param("usersr") String usersr,@Param("starttimes") String starttimes,@Param("endtimes") String endtimes);

   int findCountnewbuysmall(@Param("usersr") String usersr, @Param("starttimes") String starttimes,@Param("endtimes") String endtimes);

   int findlsrqq();


   int findlcrqq();

    List<Sqsy> allsy(@Param("userid")int userid);

   List<Sqsy> allallsy();

    void insertsy(@Param("sqsyuserid") int sqsyuserid, @Param("sqsyname") String sqsyname,@Param("sqsysc") String sqsysc,@Param("sqsytime") String sqsytime,@Param("sqsycj") double sqsycj,@Param("sqsypj") String sqsypj);

    void deletesy(@Param("sqsyid") int sqsyid);

    List<String> getoccupation();

   void tjsy(@Param("sqsyname") String sqsyname,
             @Param("sqsyuserid") Integer sqsyuserid,
             @Param("sqsycj") double sqsycj,
             @Param("sqsytime") String sqsytime,
             @Param("sqsypj") String sqsypj,
             @Param("sqsysc") String sqsysc,
             @Param("markinfo") String markinfo,
             @Param("evaluate") String evaluate);

   List<SqyxBase> selectAllPeoperdd();

   int dyage(@Param("age") Integer put);


   int xyage(@Param("age") Integer put);

   int dyagekdj(@Param("age") Integer put);


   int xyagekdj(@Param("age") Integer put);

   int dyagehy(@Param("age") Integer put);


   int xyagehy(@Param("age") Integer put);

   int dyagedz(@Param("age") Integer put);


   int xyagedz(@Param("age") Integer put);


   int dysr(@Param("income") Integer srput);


   int xysr(@Param("income") Integer srput);

    int counttabone(
            @Param("fwstarttimes") String fwstarttimes,
            @Param("fwendtimes") String fwendtimes,
            @Param("zcstarttimes") String zcstarttimes,
            @Param("zcendtimes") String zcendtimes);

   int counttabone1(
           @Param("fwstarttimes") String fwstarttimes,
           @Param("fwendtimes") String fwendtimes);

   int counttabone2(
           @Param("zcstarttimes") String zcstarttimes,
           @Param("zcendtimes") String zcendtimes);

   String findlast(@Param("zctime") String zctime);


   int findAllkdja(String productcategoryone);

   int findAllkdjb(String productcategorytwo);

   int findAllkdjc(String productcategorythree);

    List<Sqsy> findAllUserList(@Param("sqsyidlist") ArrayList<Integer> sqsyidlist);

   List<Sqsy> findAllUserList1();

    LabVo finOneLable(@Param("age") String age);

   List<SqyxBase> selectAge(@Param("fh") String fh,@Param("put") Integer put);

   List<SqyxBase> selectAgeSex(@Param("fh") String fh,@Param("put") Integer put ,@Param("sex") String sex);


   List<SqyxBase> selectSru(@Param("fh") String fh,@Param("put") Integer put);

   List<SqyxBase> selectSruSex(@Param("fh") String fh,@Param("put") Integer put,@Param("sex")String sex);


   List<SqyxBase> selectHy(@Param("fh") String fh,@Param("put") Integer put);


   List<SqyxBase> selectHysex(@Param("fh") String fh,@Param("put") Integer put,@Param("sex") String sex);



   List<SqyxBase> selectDz(@Param("fh") String fh,@Param("put") Integer put);

   List<SqyxBase> selectDzsex(@Param("fh") String fh,@Param("put") Integer put,@Param("sex") String sex);


   List<SqyxBase> selectKdj(@Param("fh") String fh,@Param("put") Integer put);

   List<SqyxBase> selectKdjsex(@Param("fh") String fh,@Param("put") Integer put,@Param("sex") String sex);


   List<SqyxBase> selectfwtime(@Param("fwstarttimes") String fwstarttimes,@Param("fwendtimes") String fwendtimes);

   List<SqyxBase> selectfwtime2(@Param("fwstarttimes") String fwstarttimes,@Param("fwendtimes") String fwendtimes);

   List<SqyxBase> selectSex(@Param("sex") String sex);

   List<SqyxBase> selectArea(@Param("city") String city);

   List<SqyxBase> selectprofession(@Param("profession") String profession);

   List<SqyxBase> selectconstellation(@Param("constellation") String constellation);

   List<SqyxBase> selectmembergrade(@Param("membergrade") String membergrade);

   List<SqyxBase> selectpreference(@Param("preference") String preference);

   List<SqyxBase> selectpreference2(@Param("preference") String preference);

   List<SqyxBase> selectnewxz(@Param("newsstarttimes") String newsstarttimes,@Param("newsendtimes") String newsendtimes);

   List<SqyxBase> selectqd(@Param("newsstarttimes") String newsstarttimes,@Param("newsendtimes") String newsendtimes);

   List<SqyxBase> selectAgeandSr(
           @Param("fh") String fh,
           @Param("put") Integer put,
           @Param("fh2") String fh2,
           @Param("put2") Integer put2);

   List<SqyxBase> selectAgeandSr2(
           @Param("fh") String fh,
           @Param("put") Integer put,
           @Param("fh2") String fh2,
           @Param("put2") Integer put2);

   List<SqyxBase> selectAgeandSr3(
           @Param("fh") String fh,
           @Param("put") Integer put,
           @Param("fh2") String fh2,
           @Param("put2") Integer put2);

   List<SqyxBase> selectAgeandSr4(
           @Param("fh") String fh,
           @Param("put") Integer put,
           @Param("fh2") String fh2,
           @Param("put2") Integer put2);
}


